Re: [SQL] Finding the "most recent" rows

At 17:28 +0300 on 29/04/1999, Chris Bitmead wrote:


>
> You say that a table is "considered an unordered set". But surely a
> table is not an unordered set if you've specified an ORDER BY clause?
> This idea is so nice, it would be ashame to dismiss it too quickly.

Charming, but alas, non standard. Moreover, what if you want to get the
maximal value, but order in an ascending in the output?

No, if you want compatible SQL, you won't use DISTINCT ON, and you will
specify the exact method of picking the distinguished value.

Furthermore, ORDER BY has to be a late stage, if it should work on the
entire results of unions, for example, or the result of groups.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma